/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : localhost
 Source Database       : wisdomparking

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 10/09/2017 23:26:48 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `manager`
-- ----------------------------
DROP TABLE IF EXISTS `manager`;
CREATE TABLE `manager` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(20) DEFAULT NULL COMMENT '用户名',
  `password` varchar(32) DEFAULT NULL COMMENT '密码',
  `createTime` datetime DEFAULT NULL COMMENT '注册时间',
  `managerGrade` int(2) DEFAULT '1' COMMENT '管理员等级 [0: 总管理员，1：车场总管理员，2：其它]',
  `managerId` int(11) DEFAULT NULL COMMENT '上级管理员Id',
  `mobile` varchar(11) DEFAULT NULL COMMENT '手机号',
  `delFlag` bit(1) DEFAULT b'0' COMMENT '删除标记 [1: 已删，0: 未删]',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `manager`
-- ----------------------------
BEGIN;
INSERT INTO `manager` VALUES ('1', 'admin', '670b14728ad9902aecba32e22fa4f6bd', '2017-09-26 23:55:25', '0', null, '18801185080', b'0'), ('2', 'fanghui', '670b14728ad9902aecba32e22fa4f6bd', '2017-09-26 23:56:00', '1', null, null, b'1'), ('3', 'test_1', '670b14728ad9902aecba32e22fa4f6bd', '2017-09-27 00:02:13', '2', '2', null, b'0'), ('5', 'fanghuiaa', 'e10adc3949ba59abbe56e057f20f883e', '2017-09-29 23:38:13', '1', null, '18801185081', b'0'), ('6', 'test_2', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-01 22:32:42', '2', '2', null, b'0'), ('7', 'test_3', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-01 22:32:44', '2', '2', null, b'0'), ('8', 'test_4', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-01 22:33:02', '2', '2', null, b'0'), ('9', 'test_5', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-01 22:33:04', '2', '2', null, b'0'), ('10', 'test_6', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-01 22:33:07', '2', '2', null, b'0'), ('11', 'test_7', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-01 22:33:09', '2', '2', null, b'0'), ('12', 'test_8', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-01 22:33:12', '2', '2', null, b'0'), ('13', 'test_9', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-01 22:33:14', '2', '2', null, b'0'), ('14', 'test_10', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-01 22:33:17', '2', '2', null, b'0'), ('15', 'test_11', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-01 22:33:19', '2', '2', null, b'0'), ('16', 'test_12', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-01 22:33:23', '2', '2', null, b'0'), ('27', 'fanghui_net', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-02 21:42:49', '1', '0', '18801185081', b'1'), ('28', 'fdfdfd', '670b14728ad9902aecba32e22fa4f6bd', '2017-10-02 21:45:33', '2', '1', '18801185083', b'0'), ('29', 'rtrtrt', '670b14728ad9902aecba32e22fa4f6bd', null, '2', '1', '18801185084', b'0'), ('30', 'test_13', 'dd4b21e9ef71e1291183a46b913ae6f2', '2017-10-02 21:50:11', '2', '2', '18801185089', b'0');
COMMIT;

-- ----------------------------
--  Table structure for `orders`
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orderNumber` varchar(25) DEFAULT NULL COMMENT '订单号',
  `parkingId` int(11) DEFAULT NULL COMMENT '产生订单车场',
  `parkingName` varchar(60) DEFAULT NULL COMMENT '车场名称',
  `parkingAddress` varchar(100) DEFAULT NULL COMMENT '车场地址',
  `userId` int(11) DEFAULT NULL COMMENT '订单用户',
  `status` int(1) DEFAULT NULL COMMENT '订单状态 [0: 计时中 1: 等待支付，2: 完成]',
  `plateNumber` varchar(20) DEFAULT NULL COMMENT '车牌',
  `startTime` datetime DEFAULT NULL COMMENT '入场时间',
  `endTime` datetime DEFAULT NULL COMMENT '离场时间',
  `amount` varchar(10) DEFAULT NULL COMMENT '订单金额 [分]',
  `payMode` varchar(10) DEFAULT NULL COMMENT '支付方式 [支付宝，微信，自动扣款，现金]',
  `identification` varchar(32) DEFAULT NULL COMMENT '车场唯一标识',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `memberFlag` bit(1) DEFAULT b'0' COMMENT '是否是车场会员 [0: 否、1: 是].  当其为车场会员时计费为0',
  `delFlag` bit(1) DEFAULT b'0' COMMENT '删除标记 [1: 已删，0: 未删]',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='订单信息表';

-- ----------------------------
--  Records of `orders`
-- ----------------------------
BEGIN;
INSERT INTO `orders` VALUES ('1', '974167', '1', '前门停车场', null, '1', '0', '京A·12345', '2017-09-23 01:12:34', null, null, null, 'a85f49ff3db5f86ad7fe59905ff1b29b', '2017-09-23 01:12:34', b'0', b'1'), ('5', 'JHZL_201709232230521481', '1', '前门停车场', 'fasdfa', '1', '2', '京A·888888', '2017-09-23 22:30:53', '2017-10-09 23:14:41', '4000', '微信', 'a85f49ff3db5f86ad7fe59905ff1b29b', '2017-09-13 22:30:53', b'0', b'0'), ('9', 'JHZL_201709240010542539', '1', '前门停车场', null, null, '2', '京A·888888', '2017-09-24 00:10:54', '2017-09-24 00:21:08', '4000.0', '微信', 'a85f49ff3db5f86ad7fe59905ff1b29b', '2017-09-24 00:10:54', b'0', b'0'), ('10', 'JHZL_201709240033491540', '1', '前门停车场', 'sd', null, '2', '京A·888888', '2017-09-24 00:33:49', '2017-09-24 00:36:16', '4000.0', '微信', 'a85f49ff3db5f86ad7fe59905ff1b29b', '2017-09-24 00:33:49', b'0', b'0'), ('11', 'JHZL_201709240037502609', '1', '前门停车场', 'sdf', null, '2', '京A·888888', '2017-09-24 00:37:51', '2017-09-24 00:46:43', '4000', '微信', 'a85f49ff3db5f86ad7fe59905ff1b29b', '2017-09-24 00:37:51', b'0', b'0'), ('13', 'JHZL_201709252131459074', '1', '前门停车场', 'sdfds', null, '0', '京A·8888888', '2017-09-25 21:31:46', '2017-09-27 23:16:43', '4000', '微信', 'a85f49ff3db5f86ad7fe59905ff1b29b', '2017-09-25 21:31:46', b'1', b'0'), ('14', 'JHZL_201710092313043934', '1', '前门停车场', '', null, '0', '京A·8888880', '2017-10-09 23:13:05', null, null, null, 'a85f49ff3db5f86ad7fe59905ff1b29b', '2017-10-09 23:13:05', b'1', null);
COMMIT;

-- ----------------------------
--  Table structure for `parking`
-- ----------------------------
DROP TABLE IF EXISTS `parking`;
CREATE TABLE `parking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) DEFAULT NULL COMMENT '停车场所名称',
  `address` varchar(100) DEFAULT NULL COMMENT '地址',
  `contacts` varchar(20) DEFAULT NULL COMMENT '联系人',
  `contactNumber` varchar(16) DEFAULT NULL COMMENT '联系电话',
  `gpsX` varchar(30) DEFAULT NULL COMMENT '经度',
  `gpsY` varchar(30) DEFAULT NULL COMMENT '纬度',
  `parkingType` varchar(50) DEFAULT NULL COMMENT '停放车种 [1: 大型客车，2: 大型货车，3: 小型客车，4: 小型货车]',
  `nature` bit(1) DEFAULT NULL COMMENT '车场性质 [1: 地上，0: 地下]',
  `parkingTotalA` int(6) DEFAULT NULL COMMENT '车场车位总数',
  `largeVehicleA` int(6) DEFAULT NULL COMMENT '车场大型车泊位A',
  `lightdutyVehicleA` int(6) DEFAULT NULL COMMENT '车场小型车泊位A',
  `chargingA` varchar(60) DEFAULT NULL COMMENT '车场计费A',
  `parkingTotalB` int(6) DEFAULT NULL COMMENT '车库车位总数',
  `largeVehicleB` int(6) DEFAULT NULL COMMENT '车库大型车泊位B',
  `lightdutyVehicleB` int(6) DEFAULT NULL COMMENT '车库小型车泊位B',
  `chargingB` varchar(60) DEFAULT NULL COMMENT '车库计费A',
  `dangerousGoods` bit(1) DEFAULT NULL COMMENT '是否可停放危险品',
  `chargingMode` varchar(1) DEFAULT NULL COMMENT '计费方式 [1: 人工，2: 自动计时自动收费，3: 自动计时人工收费, 4: 混合使用]',
  `serverTime` varchar(50) DEFAULT NULL COMMENT '营业时间',
  `serverHotline` varchar(16) DEFAULT NULL COMMENT '对外服务电话',
  `complaintsHotline` varchar(16) DEFAULT NULL COMMENT '投诉电话',
  `corporation` varchar(20) DEFAULT NULL COMMENT '法人',
  `identification` varchar(32) DEFAULT NULL COMMENT '名称与注册时间生成的唯一标识',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `surplusLargeVehicleA` int(6) DEFAULT NULL COMMENT '剩余车场大型车泊位A',
  `surplusLightdutyVehicleA` int(6) DEFAULT NULL COMMENT '剩余车场小型车泊位A',
  `surplusLargeVehicleB` int(6) DEFAULT NULL COMMENT '剩余车库大型车泊位B',
  `surplusLightdutyVehicleB` int(6) DEFAULT NULL COMMENT '剩余车库小型车泊位B',
  `managerId` int(11) DEFAULT NULL COMMENT '管理员Id',
  `delFlag` bit(1) DEFAULT b'0' COMMENT '删除标记 [1: 已删，0: 未删]',
  `noticeUrl` varchar(200) DEFAULT NULL COMMENT '抬杆通知地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='停车场信息表';

-- ----------------------------
--  Records of `parking`
-- ----------------------------
BEGIN;
INSERT INTO `parking` VALUES ('1', '前门停车场', '', '', '', '116.23', '39.54', '小型客车', b'1', '300', '100', '200', '20', '200', '80', '120', '30', b'0', '1', '', '', '', '', 'a85f49ff3db5f86ad7fe59905ff1b29b', '2017-10-09 22:05:11', '1', '2', '3', '4', null, b'0', 'http://localhost:8081/test'), ('2', '中关村地下停车场', '中关村海龙大厦地下一层', '关小羽', '13800138000', null, null, '小型客车', b'0', '300', '30', '270', '20', '100', '10', '90', '30', b'0', '3', '24小时', '13812345678', '13887654321', '关羽', '8360a98200dd9bd71343ef91d7374db6', '2017-09-25 22:15:26', null, null, null, null, null, b'0', null), ('3', '知春路中海地下停车场', '中海大厦地下一层', '王小羽', '13800138000', null, null, '小型客车', b'0', '300', '30', '270', '20', '100', '10', '90', '30', b'0', '3', '24小时', '13812345678', '13887654321', '王天', 'ec715fccc11b8c5dec1055488560fecb', '2017-09-26 23:59:10', null, null, null, null, '2', b'0', null), ('4', '知春路中航大厦地下停车场', '中航大厦地下一层', '王大羽', '13800138000', null, null, '小型客车', b'0', '300', '30', '270', '20', '100', '10', '90', '30', b'0', '3', '24小时', '13812345678', '13887654321', '王小天', '5d056ac9608671c532806693dde20aef', '2017-09-28 01:14:16', null, null, null, null, null, b'0', null), ('6', '远洋大厦停车场', '北京市西城区复兴门大街158号远洋大厦', '张沃', '18801101010', null, null, '小型客车', b'1', '300', '50', '250', '25', '100', '30', '70', '35', b'0', '2', '24小时', '12345678910', '01234567891', '张沃', 'c7a819cee2806fdc9dc673699b59ee02', '2017-10-04 21:56:48', null, null, null, null, null, b'0', null), ('7', '知昌春路中航大厦地下停车场', '中航大厦地下一层', '王大羽', '13800138000', null, null, '小型客车', b'0', '300', '30', '270', '20', '100', '10', '90', '30', b'0', '3', '24小时', '13812345678', '13887654321', '王小天', '1825054dff7280c259048ed208566adc', '2017-10-04 22:03:15', null, null, null, null, null, b'0', null), ('8', '远洋大厦停车场', '北京市西城区复兴门大街158号远洋大厦', '张沃', '18801101010', null, null, '小型客车', b'1', '300', '50', '250', '25', '100', '30', '70', '35', b'0', '4', '24小时', '12345678910', '01234567891', '张大沃', '0d5c25e60bc02bd9140514dea66aafe8', '2017-10-04 22:06:32', null, null, null, null, '2', b'0', null), ('9', '远洋大厦停车场2', '北京市西城区复兴门大街158号远洋大厦', '张沃', '18801101011', null, null, '小型客车', b'0', '100', '50', '50', '40', '100', '60', '40', '60', b'0', '2', '24小时', '12345678910', '01234567891', '张大沃', '33246095c7d57544466f780d2b9950b5', '2017-10-04 22:14:36', null, null, null, null, '2', b'0', null);
COMMIT;

-- ----------------------------
--  Table structure for `rawdata`
-- ----------------------------
DROP TABLE IF EXISTS `rawdata`;
CREATE TABLE `rawdata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identification` varchar(32) DEFAULT NULL COMMENT '车场标识',
  `realTimeData` varchar(2000) DEFAULT NULL COMMENT '车场发送的实时数据',
  `putInStorageMark` bit(1) DEFAULT NULL COMMENT '入库标记 [0: 未入本地库，1: 已入本地库]',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `putInStorageMode` varchar(20) DEFAULT NULL COMMENT '本地入库模式',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='车场原始数据';

-- ----------------------------
--  Records of `rawdata`
-- ----------------------------
BEGIN;
INSERT INTO `rawdata` VALUES ('1', 'a85f49ff3db5f86ad7fe59905ff1b29b', '{\"site\":\"27\",\"identification\":\"a85f49ff3db5f86ad7fe59905ff1b29b\",\"updateTime\":\"2017-09-28 13:19:10\",\"plateNumber\":\"京·A773639\",\"bitSite\":\"23\"}', b'0', '2017-09-27 23:36:12', null), ('2', '5d056ac9608671c532806693dde20aef', '{\"site\":\"27\",\"identification\":\"5d056ac9608671c532806693dde20aef\",\"updateTime\":\"2017-09-28 13:19:10\",\"plateNumber\":\"京·A773639\",\"bitSite\":\"23\"}', b'0', '2017-10-09 23:16:39', null), ('3', 'c7a819cee2806fdc9dc673699b59ee02', null, b'1', '2017-10-04 21:56:48', null), ('4', '1825054dff7280c259048ed208566adc', null, b'1', '2017-10-04 22:03:15', null), ('5', '0d5c25e60bc02bd9140514dea66aafe8', null, b'1', '2017-10-04 22:06:32', null), ('6', '33246095c7d57544466f780d2b9950b5', null, b'1', '2017-10-04 22:14:36', null), ('7', 'a383c6dd9324398157b093cb2e7eef59', null, b'1', '2017-10-09 21:58:00', null), ('8', '7f785088093f132d3a314437a312c33e', null, b'1', '2017-10-09 22:01:00', null), ('9', 'eab392fc7210e85728f4f4c94f82c291', null, b'1', '2017-10-09 22:05:11', null);
COMMIT;

-- ----------------------------
--  Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mobileNumber` varchar(11) DEFAULT NULL COMMENT '手机号',
  `password` varchar(32) DEFAULT NULL COMMENT '密码',
  `idNumber` varchar(18) DEFAULT NULL COMMENT '身份证号',
  `address` varchar(100) DEFAULT NULL COMMENT '地址',
  `headPortrait` varchar(60) DEFAULT NULL COMMENT '头像',
  `identifyingCode` varchar(6) DEFAULT NULL COMMENT '验证码',
  `tempMobile` varchar(11) DEFAULT NULL COMMENT '手机号临时存放',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `defaultVehicleType` int(1) DEFAULT '3' COMMENT '车辆类型 [1: 大型客车，2: 大型货车，3: 小型客车，4: 小型货车]',
  `delFlag` bit(1) DEFAULT b'0' COMMENT '删除标记 [1: 已删，0: 未删]',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
--  Records of `user`
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('1', '18801185080', '670b14728ad9902aecba32e22fa4f6bd', '234', 'a', 'imgupload/logo.png', '375856', '', '2017-09-19 23:31:22', '3', b'0'), ('2', '12341', 'fsqwerqwe', '34556', 'sdf', 'rer', '343', null, '2017-10-17 22:30:17', '3', b'0'), ('3', '2345234', '53452', '3245', null, null, '345234', null, '2017-10-03 22:35:12', '3', b'0'), ('4', '345676', 'rqwe', 'rwr', null, null, null, null, '2017-10-25 22:35:27', '3', b'0');
COMMIT;

-- ----------------------------
--  Table structure for `vehicleInfo`
-- ----------------------------
DROP TABLE IF EXISTS `vehicleInfo`;
CREATE TABLE `vehicleInfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) DEFAULT NULL COMMENT '用户Id',
  `plateNumber` varchar(20) DEFAULT NULL COMMENT '车牌号',
  `engineNumber` varchar(20) DEFAULT NULL COMMENT '发动机号',
  `validatingState` bit(1) DEFAULT b'0' COMMENT '验证状态',
  `activatedState` bit(1) DEFAULT b'1' COMMENT '激活状态',
  `vehicleLicensePic` varchar(60) DEFAULT NULL COMMENT '行驶证图片',
  `vehicleType` tinyint(1) DEFAULT NULL COMMENT '车辆类型 [1: 大型客车，2: 大型货车，3: 小型客车，4: 小型货车]',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `delFlag` bit(1) DEFAULT b'0' COMMENT '删除标记 [1: 已删，0: 未删]',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='用户车辆信息表';

-- ----------------------------
--  Records of `vehicleInfo`
-- ----------------------------
BEGIN;
INSERT INTO `vehicleInfo` VALUES ('1', '1', '京A·12345', 'ABCDEFG', b'1', b'1', 'imgupload/vehicleInfo/1-cover.jpg', '3', '2017-09-20 22:12:27', b'0'), ('2', '1', '京A·54321', 'DFSSKFF', b'1', b'1', 'mgupload/vehicleInfo/1-cover.jpg', '2', '2017-09-20 22:16:08', b'0'), ('3', null, '京A·888888', null, null, null, null, null, '2017-09-23 01:23:46', b'0'), ('4', null, '京A·8888880', null, null, null, null, null, '2017-10-09 23:13:05', null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
